Tabela FormInstance

Definicja tabeli FormInstance

Name

FormInstance

Code

FormInstance

Comment

 


Lista kolumn tabeli FormInstance

Name

Code

FormInstanceID

FormInstanceID

FormDefinitionID

FormDefinitionID

PersonID

PersonID

FormStatusDictionaryValueID

FormStatusDictionaryValueID

DateValue

DateValue

PinVerificationPerson

PinVerificationPerson


Kolumna FormInstanceID tabeli FormInstance

Definicja kolumny FormInstanceID tabeli FormInstance

Name

FormInstanceID

Code

FormInstanceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FormDefinitionID tabeli FormInstance

Definicja kolumny FormDefinitionID tabeli FormInstance

Name

FormDefinitionID

Code

FormDefinitionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli FormInstance

Definicja kolumny PersonID tabeli FormInstance

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FormStatusDictionaryValueID tabeli FormInstance

Definicja kolumny FormStatusDictionaryValueID tabeli FormInstance

Name

FormStatusDictionaryValueID

Code

FormStatusDictionaryValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

Oznaczenie statusu formularza


Kolumna DateValue tabeli FormInstance

Definicja kolumny DateValue tabeli FormInstance

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PinVerificationPerson tabeli FormInstance

Definicja kolumny PinVerificationPerson tabeli FormInstance

Name

PinVerificationPerson

Code

PinVerificationPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna przechowujaca osobe zatwierdzajaca formularz pinem


Lista kluczy tabeli FormInstance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli FormInstance

Definicja klucza Identifier_1 tabeli FormInstance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment